Some days ago, I have been searching for PHP on the Internet for how to connect to SQL server2005 for a long time. I haven't found it. I also asked Baidu for a long time, orNo one knows how to connect to SQL server2005. It's still easy to use. I
Each program that needs to connect to the database must first open it on the server. There are many ways to do this!
Using System Data Source (DSN)
This must be set on the server. This is the best and fastest way to access data. Because it only
Data | Data source I am a beginner of ASP, a bit deeper, I'm puzzled by the connection to the database, and I often see that there are two ways to use the same Microsoft Access database, or three or even four of connections, which I don't understand
{--------------------------------------------------------------------}{}{Unit name: createodbc}{}{Author: Ji Tao}{}{Version: V1.0}{}{Date: 2006-7-9}{}{Purpose and Description: automatically create data sources for accsee, SQL Server, DB2, and Oracle}
Author: Tonny
Reprint please show the Source: http://www.weiw.com
Database structure operations. Adapts to common databases such as Access,sql server.
1. Establish a connection.
Can be connected through ODBC or OLE DB.
Set GOBJDC =
If you're like me, your home page is for a variety of picture services, it's quite necessary to know which pictures are popular and which are not popular. Here, to tell you about how I use ASP to solve this problem.
Let's analyze it first. Generally
Method 1: Using the CreateTableDef method
CreateTableDef method to create a linked table. To use this method, create a new module, and then add the following attachdsnlesstable function to the new module.
Copy Code code as follows:
Data | database | Database structure Author: Tonny
Reprint please show the Source: http://www.weiw.com
Database structure operations. Adapts to common databases such as Access,sql server.
1. Establish a connection.
Can be connected through ODBC
' Set up the motion pull option (tier three)
Mydsn= "PROVIDER=SQLOLEDB; Data Source=jackal; Initial catalog=pubs; User Id=sa; Password= "
Strsql= "Select Color.color, Fruit.fruit, price.cost from color join fruit on color.id=fruit. Colorid join
Online
Curq = Request.Form ("Curq")
ANSW = Request.Form ("ANSW")
Correct=request.form ("correct")
Wrong=request.form ("wrong")
' Poor man ' s IsNull Code goes here
If poormansisnull (CURQ) Then
CURQ = 1
correct = 0
Wrong = 0
End If
If
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.